-- 客诉率明细剔除表
-- drop table complaint_report_culling_record;
CREATE EXTERNAL TABLE jms_ods.complaint_report_culling_record
(
    id                      bigint           comment '主键id',
    waybill_no              string           comment '运单号',
    culling_start_time      timestamp        comment '剔除开始日期',
    culling_end_time        timestamp        comment '剔除结束日期',
    work_type               tinyint          comment '剔除渠道(0.全部 【1.普通工单】、【2.平台工单】、【3.理赔工单】、【4.邮政工单】)',
    culling_type            tinyint          comment '剔除方式( 1.运单号)',
    create_by               bigint           comment '创建人ID',
    create_by_name          string           comment '创建人名称',
    create_time             timestamp        comment '创建时间',
    update_by               bigint           comment '更新人id',
    update_by_name          string           comment '最后修改人名称',
    update_time             timestamp        comment '更新时间'
) comment '客诉率明细剔除表'
PARTITIONED BY (
   `dt` string COMMENT '时间分区(yyyyMMdd)')
stored as parquet
LOCATION
   '/dw/hive/jms_ods.db/external/complaint_report_culling_record'
TBLPROPERTIES (
   'discover.partitions' = 'false',
   'parquet.column.index.access' = 'true'
);